instr oracle 在 SUBSTR and INSTR SQL Oracle - Stack Overflow 的評價 INSTR (PHONE, '-') gives the index of - in the PHONE column, in your case 4 and then SUBSTR(PHONE, 1, 4 - 1) or SUBSTR(PHONE, 1, 3) ... <看更多>
